Conditional Changing of Blank Form

In some cases you may want to change a field's appearance depending on the data it represents. For example, you may want to highlight items that are expensive, or low in stock. This can be done with script.

To do this, complete the following steps:

Open the C1ReportDesigner application. For more information on how to access C1ReportDesigner, see Accessing C1ReportDesigner from Visual Studio.
Create a new report|tag=Creating a Basic Report Definition or open an existing report. Once you have the report in the C1ReportDesigner application, you can modify the report properties.
Click the Close Print Preview button to begin editing the report.
In Design mode, select Detail from the drop-down list above the Properties window (since this section contains the fields to add conditional formatting to).
Locate the C1.C1Report.Section.OnFormat property and click the empty field next to it, and then click the ellipsis button.
The VBScript Editor appears. Enter the following VBScript expression in the code editor:

' VBScript: Detail.OnFormat

If UnitsInStock + UnitsOnOrder < ReorderLevel And _

Discontinued = False Then

Detail.BackColor = rgb(255,190,190)

Else

Detail.BackColor = vbWhite

Endif

The script changes the Detail section's C1.C1Report.Section.BackColor property depending on the value of the fields UnitsInStock, UnitsOnOrder, ReorderLevel, and Discontinued.

Sample Report Available:
For the complete report, see report "16: Conditional Formatting" in the CommonTasks.xml report definition file, which is available for download from the CommonTasks sample on the ComponentOne HelpCentral Sample page.